/*
 Navicat Premium Data Transfer

 Source Server         : ipc
 Source Server Type    : MySQL
 Source Server Version : 50520
 Source Host           : localhost
 Source Database       : ipd

 Target Server Type    : MySQL
 Target Server Version : 50520
 File Encoding         : utf-8

 Date: 05/10/2012 10:33:19 AM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `l_alarm`
-- ----------------------------
DROP TABLE IF EXISTS `l_alarm`;
CREATE TABLE `l_alarm` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '报警记录ID',
  `uid` int(11) DEFAULT NULL,
  `dt_create` datetime DEFAULT NULL COMMENT '建立时间',
  `dt_modify` datetime DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `status` int(11) DEFAULT NULL,
  `stype` varchar(255) DEFAULT NULL COMMENT '状态类名',
  `oid` int(11) DEFAULT NULL COMMENT '对象ID（stdid eid）',
  `prop_name` varchar(255) DEFAULT NULL COMMENT '属性名',
  `prop_val` varchar(255) DEFAULT NULL COMMENT '属性值',
  `level` varchar(50) DEFAULT NULL COMMENT '报警级别',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='报警日志记录表';

-- ----------------------------
--  Records of `l_alarm`
-- ----------------------------
BEGIN;
INSERT INTO `l_alarm` VALUES ('1', null, '2012-02-16 00:00:00', null, '设备【1】温度报警', null, null, '1', 'Temperature', '44', '2'), ('2', null, '2012-02-22 00:00:00', null, '设备【2】温度报警', null, null, '2', 'Temperature', '32', '2'), ('3', null, '2012-02-05 00:00:00', null, '设备【3】温度报警', null, null, '3', 'Temperature', '47', '2');
COMMIT;

-- ----------------------------
--  Table structure for `l_record`
-- ----------------------------
DROP TABLE IF EXISTS `l_record`;
CREATE TABLE `l_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `dt_create` datetime DEFAULT NULL,
  `dt_modify` datetime DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `oid` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `stype` varchar(255) DEFAULT NULL,
  `result` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `l_server`
-- ----------------------------
DROP TABLE IF EXISTS `l_server`;
CREATE TABLE `l_server` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `dt_create` datetime DEFAULT NULL,
  `dt_modify` datetime DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `sno` varchar(255) DEFAULT NULL,
  `ip_addr` varchar(255) DEFAULT NULL,
  `port` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `m_inbox`
-- ----------------------------
DROP TABLE IF EXISTS `m_inbox`;
CREATE TABLE `m_inbox` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mid` int(11) DEFAULT NULL,
  `uid` int(11) DEFAULT NULL,
  `tm_check` datetime DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `m_inbox`
-- ----------------------------
BEGIN;
INSERT INTO `m_inbox` VALUES ('1', '1', '1', null, null), ('2', '2', '1', null, null);
COMMIT;

-- ----------------------------
--  Table structure for `m_message`
-- ----------------------------
DROP TABLE IF EXISTS `m_message`;
CREATE TABLE `m_message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mid` int(11) DEFAULT NULL COMMENT 'parent message',
  `uid` int(11) DEFAULT NULL,
  `send_to` varchar(255) DEFAULT NULL,
  `uname` varchar(255) DEFAULT NULL,
  `online` int(11) DEFAULT NULL,
  `stype` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `content` varchar(255) DEFAULT NULL,
  `tm_create` datetime DEFAULT NULL,
  `tm_modify` datetime DEFAULT NULL,
  `tm_reply` datetime DEFAULT NULL,
  `rname` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `m_message`
-- ----------------------------
BEGIN;
INSERT INTO `m_message` VALUES ('1', null, '1', null, '姓名1', '0', null, '说点什么吧', '是xxx是', '2012-02-25 18:11:43', null, null, null, null), ('2', null, '1', null, '姓名1', '0', null, 'eee', 'www', '2012-02-26 19:49:01', null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `n_base`
-- ----------------------------
DROP TABLE IF EXISTS `n_base`;
CREATE TABLE `n_base` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vid` int(11) DEFAULT NULL,
  `itype` int(11) DEFAULT NULL,
  `language` int(11) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `uid` int(11) DEFAULT NULL,
  `status_publish` int(11) DEFAULT NULL,
  `status_comment` int(11) DEFAULT NULL,
  `dt_created` datetime DEFAULT NULL,
  `dt_changed` datetime DEFAULT NULL,
  `tnid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `n_base`
-- ----------------------------
BEGIN;
INSERT INTO `n_base` VALUES ('1', null, '1', '1', '雍和宫', '1', null, null, null, '2012-03-22 06:42:32', null), ('3', '1', '2', null, null, '1', null, null, '2012-03-21 17:34:44', null, '1');
COMMIT;

-- ----------------------------
--  Table structure for `n_image`
-- ----------------------------
DROP TABLE IF EXISTS `n_image`;
CREATE TABLE `n_image` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nid` int(11) DEFAULT NULL,
  `uid` int(11) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `detail` text,
  `width` int(11) DEFAULT NULL,
  `height` int(11) DEFAULT NULL,
  `fsize` int(11) DEFAULT NULL,
  `uri` varchar(255) DEFAULT NULL,
  `dt_created` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `n_image`
-- ----------------------------
BEGIN;
INSERT INTO `n_image` VALUES ('1', '1', null, 'kkk', null, null, null, null, null, null), ('2', '3', null, '111', null, null, null, null, '_[2012~03~21~3]在 11-10-30 上午8.56 拍摄的照片.jpg', null);
COMMIT;

-- ----------------------------
--  Table structure for `n_museum`
-- ----------------------------
DROP TABLE IF EXISTS `n_museum`;
CREATE TABLE `n_museum` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nid` int(11) DEFAULT NULL,
  `uid` int(11) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `stype` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `longitude` float DEFAULT NULL,
  `latitude` float DEFAULT NULL,
  `summery` text,
  `homepage` varchar(255) DEFAULT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `desc_ticket` text,
  `desc_open` text,
  `desc_traffic` text,
  `dt_created` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `n_museum`
-- ----------------------------
BEGIN;
INSERT INTO `n_museum` VALUES ('1', '1', null, '33388', '##陈列内容#综合类;##隶属#科技;##等级#国家一级', '##北京市#丰台区', null, null, '11', null, '22', '33', '44', '55', null), ('2', '1', null, '666', '##河北省 #石家庄市;##河北省 # 张家口市;##山西省#太原市', '##北京市#海淀区', null, null, null, null, null, null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `o_attachment`
-- ----------------------------
DROP TABLE IF EXISTS `o_attachment`;
CREATE TABLE `o_attachment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entity_name` varchar(255) DEFAULT NULL,
  `entity_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL COMMENT '名称',
  `stype` varchar(255) DEFAULT NULL COMMENT '类型',
  `suffix` varchar(255) DEFAULT NULL,
  `spec` varchar(255) DEFAULT NULL,
  `size` int(11) DEFAULT NULL COMMENT '文件大小',
  `path` varchar(2048) DEFAULT NULL COMMENT '路径',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `status` int(11) DEFAULT NULL COMMENT '状态',
  `tm_create` datetime DEFAULT NULL,
  `tm_modify` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `o_device`
-- ----------------------------
DROP TABLE IF EXISTS `o_device`;
CREATE TABLE `o_device` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '设备序号',
  `mid` int(11) NOT NULL COMMENT '设备类型序号',
  `sid` int(11) NOT NULL COMMENT '地理位置序号',
  `lid` int(11) DEFAULT NULL,
  `dt_create` datetime DEFAULT NULL COMMENT '创建时间',
  `dt_modify` datetime DEFAULT NULL COMMENT '修改时间',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `status` int(11) DEFAULT NULL COMMENT '启用,禁用',
  `name` varchar(255) DEFAULT NULL COMMENT '设备名称',
  `sno` varchar(255) DEFAULT NULL COMMENT '设备编号',
  `position` varchar(255) DEFAULT NULL COMMENT '机柜编号',
  `direction` varchar(255) DEFAULT NULL COMMENT '所属域/子系统',
  `properties` varchar(4096) DEFAULT NULL,
  `ip_addr` varchar(255) DEFAULT NULL COMMENT 'ip地址',
  `ip_mask` varchar(255) DEFAULT NULL,
  `ip_gateway` varchar(255) DEFAULT NULL,
  `ip_mac` varchar(255) DEFAULT NULL,
  `islinked` int(11) DEFAULT NULL COMMENT '设备是否连通',
  `iconid` varchar(255) DEFAULT NULL COMMENT '复用拓朴图设备图标ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='设备表';

-- ----------------------------
--  Records of `o_device`
-- ----------------------------
BEGIN;
INSERT INTO `o_device` VALUES ('1', '1', '1', null, null, null, null, '1', '设备1', '65777', null, null, null, '127.0.0.1', null, null, null, null, null), ('2', '1', '2', null, null, null, null, '1', '设备248', '5566yy', null, null, null, '127.0.0.1', null, null, null, null, null), ('3', '1', '3', null, null, null, null, '1', '设备333', '447766', null, null, null, '127.0.0.1', null, null, null, null, null), ('4', '1', '339', null, null, null, null, '1', '名称111', '编号11', null, null, null, '127.0.0.1', null, null, null, null, null), ('5', '0', '339', null, null, null, null, '0', '2222s', '2222', null, null, null, null, null, null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `o_device_cfg`
-- ----------------------------
DROP TABLE IF EXISTS `o_device_cfg`;
CREATE TABLE `o_device_cfg` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '设备配置信息序号',
  `mid` int(11) NOT NULL COMMENT '设备型号序号',
  `name` varchar(255) DEFAULT NULL COMMENT '参数名称',
  `dispalyname` varchar(255) DEFAULT NULL,
  `style` varchar(255) DEFAULT NULL COMMENT '参数类型,文本、下拉框...',
  `style_param` varchar(255) DEFAULT NULL COMMENT '类型补充值,select option',
  `valtype` varchar(20) DEFAULT NULL COMMENT '参数值类型\r\n            1:整形 2:字符串',
  `ordernum` int(11) DEFAULT NULL COMMENT '显示顺序',
  `vaildconditon` varchar(255) DEFAULT NULL COMMENT '参数有效条件',
  `rule` varchar(255) DEFAULT NULL COMMENT '参数转换规则',
  `coefficient` double(10,2) DEFAULT NULL COMMENT '系数',
  `unit` varchar(50) DEFAULT NULL COMMENT '计量单位',
  `tm_create` datetime DEFAULT NULL COMMENT '创建时间',
  `tm_modify` datetime DEFAULT NULL COMMENT '修改时间',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `oid` varchar(255) DEFAULT NULL COMMENT '设备参数OID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='设备配置信息表';

-- ----------------------------
--  Table structure for `o_device_copy`
-- ----------------------------
DROP TABLE IF EXISTS `o_device_copy`;
CREATE TABLE `o_device_copy` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '设备序号',
  `mid` int(11) NOT NULL COMMENT '设备类型序号',
  `sid` int(11) NOT NULL COMMENT '地理位置序号',
  `lid` int(11) DEFAULT NULL,
  `dt_create` datetime DEFAULT NULL COMMENT '创建时间',
  `dt_modify` datetime DEFAULT NULL COMMENT '修改时间',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `status` int(11) DEFAULT NULL COMMENT '启用,禁用',
  `name` varchar(255) DEFAULT NULL COMMENT '设备名称',
  `sno` varchar(255) DEFAULT NULL COMMENT '设备编号',
  `position` varchar(255) DEFAULT NULL COMMENT '机柜编号',
  `direction` varchar(255) DEFAULT NULL COMMENT '所属域/子系统',
  `properties` varchar(4096) DEFAULT NULL,
  `ip_addr` varchar(255) DEFAULT NULL COMMENT 'ip地址',
  `ip_mask` varchar(255) DEFAULT NULL,
  `ip_gateway` varchar(255) DEFAULT NULL,
  `ip_mac` varchar(255) DEFAULT NULL,
  `islinked` int(11) DEFAULT NULL COMMENT '设备是否连通',
  `iconid` varchar(255) DEFAULT NULL COMMENT '复用拓朴图设备图标ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='设备表';

-- ----------------------------
--  Table structure for `o_device_menu`
-- ----------------------------
DROP TABLE IF EXISTS `o_device_menu`;
CREATE TABLE `o_device_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '序号',
  `uid` int(11) DEFAULT NULL,
  `mid` int(11) DEFAULT NULL COMMENT '设备型号序号',
  `dt_create` datetime DEFAULT NULL,
  `dt_modify` datetime DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `smode` varchar(255) DEFAULT NULL COMMENT '方式',
  `smode_para` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `ord` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `o_device_type`
-- ----------------------------
DROP TABLE IF EXISTS `o_device_type`;
CREATE TABLE `o_device_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `uid` int(11) DEFAULT NULL,
  `dt_create` datetime DEFAULT NULL,
  `dt_modify` datetime DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `status` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL COMMENT '设备属性',
  `stype` varchar(255) DEFAULT NULL COMMENT '设备型号',
  `smode` varchar(255) DEFAULT NULL COMMENT '设备状态采集方式,与本地系统配置对应(udp/snmp/trap)',
  `handle` varchar(255) DEFAULT NULL,
  `handle_para` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='设备类型及型号基表';

-- ----------------------------
--  Records of `o_device_type`
-- ----------------------------
BEGIN;
INSERT INTO `o_device_type` VALUES ('1', null, null, null, null, '1', 'Camera', '007', 'Cam', null, null);
COMMIT;

-- ----------------------------
--  Table structure for `o_location`
-- ----------------------------
DROP TABLE IF EXISTS `o_location`;
CREATE TABLE `o_location` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `dt_create` datetime DEFAULT NULL,
  `dt_modify` datetime DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `longitude` double DEFAULT NULL,
  `latitude` double DEFAULT NULL,
  `bw` double DEFAULT NULL,
  `bn` double DEFAULT NULL,
  `be` double DEFAULT NULL,
  `bs` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=504 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `o_location`
-- ----------------------------
BEGIN;
INSERT INTO `o_location` VALUES ('339', null, null, null, null, '1', 'Antarctica', null, null, '-179.999923706055', '-60.5155258178711', '179.999923706055', '-89.9999084472656'), ('340', null, null, null, null, '1', 'Canada', null, null, '-141.000015258789', '83.1106338500977', '-52.6362838745117', '41.6759757995605'), ('341', null, null, null, null, '1', 'United States', null, null, '-124.733261108398', '49.3886184692383', '-66.9547958374023', '24.5442428588867'), ('342', null, null, null, null, '1', 'Belize', null, null, '-89.2248229980469', '18.4965591430664', '-87.776969909668', '15.8892984390259'), ('343', null, null, null, null, '1', 'Costa Rica', null, null, '-85.9506378173828', '11.2168207168579', '-82.5559768676758', '8.03297328948975'), ('344', null, null, null, null, '1', 'El Salvador', null, null, '-90.1286697387695', '14.445068359375', '-87.6921539306641', '13.1486778259277'), ('345', null, null, null, null, '1', 'Guatemala', null, null, '-92.2363052368164', '17.8152236938477', '-88.2231903076172', '13.7373008728027'), ('346', null, null, null, null, '1', 'Honduras', null, null, '-89.3508071899414', '16.5102596282959', '-83.155387878418', '12.9824094772339'), ('347', null, null, null, null, '1', 'Mexico', null, null, '-118.453964233398', '32.7167663574219', '-86.7033767700195', '14.5328645706177'), ('348', null, null, null, null, '1', 'Nicaragua', null, null, '-87.6903228759766', '15.0259103775024', '-82.73828125', '10.7075414657593'), ('349', null, null, null, null, '1', 'Panama', null, null, '-83.0514526367188', '9.6375150680542', '-77.1740951538086', '7.19790506362915'), ('350', null, null, null, null, '1', 'Cuba', null, null, '-84.9574432373047', '23.2260456085205', '-74.1317672729492', '19.8280792236328'), ('351', null, null, null, null, '1', 'Dominican Republic', null, null, '-72.0035018920898', '19.9298610687256', '-68.3199920654297', '17.543155670166'), ('352', null, null, null, null, '1', 'Haiti', null, null, '-74.4785919189453', '20.0878219604492', '-71.6133499145508', '18.0210285186768'), ('353', null, null, null, null, '1', 'Jamaica', null, null, '-78.3666458129883', '18.5269794464111', '-76.1803131103516', '17.7035503387451'), ('354', null, null, null, null, '1', 'Puerto Rico', null, null, '-67.9427337646484', '18.5201683044434', '-65.2427291870117', '17.9264030456543'), ('355', null, null, null, null, '1', 'Argentina', null, null, '-73.5829849243164', '-21.7812747955322', '-53.5918273925781', '-55.0613212585449'), ('356', null, null, null, null, '1', 'Brazil', null, null, '-73.9855499267578', '5.2648777961731', '-32.392993927002', '-33.7507133483887'), ('357', null, null, null, null, '1', 'Bolivia', null, null, '-69.6407699584961', '-9.68056583404541', '-57.4580917358398', '-22.8961353302002'), ('358', null, null, null, null, '1', 'Chile', null, null, '-109.455902099609', '-17.5075492858887', '-66.4175491333008', '-55.9163551330566'), ('359', null, null, null, null, '1', 'Colombia', null, null, '-81.7281188964844', '13.38050365448', '-66.8698272705078', '-4.22586965560913'), ('360', null, null, null, null, '1', 'Ecuador', null, null, '-91.6618881225586', '1.41893422603607', '-75.1845779418945', '-4.99882364273071'), ('361', null, null, null, null, '1', 'French Guiana', null, null, '-54.5425186157227', '5.77649688720703', '-51.6139450073242', '2.12709355354309'), ('362', null, null, null, null, '1', 'Guyana', null, null, '-61.3847694396973', '8.55756855010986', '-56.4802436828613', '1.17507982254028'), ('363', null, null, null, null, '1', 'Paraguay', null, null, '-62.6470832824707', '-19.294038772583', '-54.259349822998', '-27.6087417602539'), ('364', null, null, null, null, '1', 'Peru', null, null, '-81.3267517089844', '-0.012976998463273', '-68.6779708862305', '-18.3497314453125'), ('365', null, null, null, null, '1', 'Suriname', null, null, '-58.0865669250488', '6.00454664230347', '-53.9774856567383', '1.8311448097229'), ('366', null, null, null, null, '1', 'Trinidad and Tobago', null, null, '-61.9237785339355', '11.3383436203003', '-60.5179290771484', '10.0361032485962'), ('367', null, null, null, null, '1', 'Uruguay', null, null, '-58.4427261352539', '-30.0822219848633', '-53.0739288330078', '-34.9808235168457'), ('368', null, null, null, null, '1', 'Venezuela', null, null, '-73.3540878295898', '12.201904296875', '-59.8037757873535', '0.626310884952545'), ('369', null, null, null, null, '1', 'Albania', null, null, '19.2939682006836', '42.6656150817871', '21.0684757232666', '39.6483535766602'), ('370', null, null, null, null, '1', 'Austria', null, null, '9.53591442108154', '49.0170631408691', '17.1627254486084', '46.3780250549316'), ('371', null, null, null, null, '1', 'Belarus', null, null, '23.1768856048584', '56.1658134460449', '32.770809173584', '51.2564086914062'), ('372', null, null, null, null, '1', 'Belgium', null, null, '2.54694366455078', '51.5054512023926', '6.40386152267456', '49.4936027526855'), ('373', null, null, null, null, '1', 'Bosnia Herzegovina', null, null, '15.7189435958862', '45.239200592041', '19.6222267150879', '42.5461044311523'), ('374', null, null, null, null, '1', 'Bulgaria', null, null, '22.3711624145508', '44.2176475524902', '28.6121692657471', '41.2420768737793'), ('375', null, null, null, null, '1', 'Croatia', null, null, '13.4932203292847', '46.5387573242188', '19.4273910522461', '42.4358825683594'), ('376', null, null, null, null, '1', 'Cyprus', null, null, '32.273078918457', '35.7015342712402', '34.5979232788086', '34.5634918212891'), ('377', null, null, null, null, '1', 'Czech Republic', null, null, '12.0937032699585', '51.0536079406738', '18.8522205352783', '48.5813751220703'), ('378', null, null, null, null, '1', 'Denmark', null, null, '8.07560920715332', '57.7484245300293', '15.1588354110718', '54.5623817443848'), ('379', null, null, null, null, '1', 'Estonia', null, null, '21.8375816345215', '59.6762313842773', '28.2099742889404', '57.516185760498'), ('380', null, null, null, null, '1', 'Finland', null, null, '19.5207176208496', '70.096061706543', '31.5809459686279', '59.8087730407715'), ('381', null, null, null, null, '1', 'France', null, null, '-5.14222288131714', '51.0928115844727', '9.56155776977539', '41.3715744018555'), ('382', null, null, null, null, '1', 'Germany', null, null, '5.865638256073', '55.0556411743164', '15.0398902893066', '47.2757720947266'), ('383', null, null, null, null, '1', 'Greece', null, null, '19.3744430541992', '41.7574234008789', '28.2463912963867', '34.8096351623535'), ('384', null, null, null, null, '1', 'Greenland', null, null, '-73.0420379638672', '83.6273651123047', '-11.3123178482056', '59.7773971557617'), ('385', null, null, null, null, '1', 'Hungary', null, null, '16.1118869781494', '48.5856742858887', '22.9060020446777', '45.7436027526855'), ('386', null, null, null, null, '1', 'Iceland', null, null, '-24.5465259552002', '66.5346450805664', '-13.495813369751', '63.3932456970215'), ('387', null, null, null, null, '1', 'Ireland', null, null, '-10.4785575866699', '55.3879241943359', '-6.00238847732544', '51.4515800476074'), ('388', null, null, null, null, '1', 'Italy', null, null, '6.61488819122314', '47.0952033996582', '18.51344871521', '36.652774810791'), ('389', null, null, null, null, '1', 'Latvia', null, null, '20.9742736816406', '58.0823135375977', '28.2411689758301', '55.6688537597656'), ('390', null, null, null, null, '1', 'Lithuania', null, null, '20.9415245056152', '56.4469223022461', '26.8719463348389', '53.9012985229492'), ('391', null, null, null, null, '1', 'Luxembourg', null, null, '5.7345552444458', '50.1849479675293', '6.52847290039062', '49.4465789794922'), ('392', null, null, null, null, '1', 'Macedonia', null, null, '20.464693069458', '42.3618125915527', '23.0381412506104', '40.8601875305176'), ('393', null, null, null, null, '1', 'Moldova', null, null, '26.6189403533936', '48.4901733398438', '30.1354484558105', '45.468879699707'), ('394', null, null, null, null, '1', 'Montenegro', null, null, '18.4613037109375', '43.570140838623', '20.3588352203369', '41.8501586914062'), ('395', null, null, null, null, '1', 'Netherland', null, null, '3.36255574226379', '53.5122032165527', '7.22794485092163', '50.7539138793945'), ('396', null, null, null, null, '1', 'Norway', null, null, '4.65016651153564', '71.188117980957', '30.9455585479736', '57.977912902832'), ('397', null, null, null, null, '1', 'Poland', null, null, '14.1229982376099', '54.8391418457031', '24.1507511138916', '49.0063591003418'), ('398', null, null, null, null, '1', 'Portugal', null, null, '-9.49594497680664', '42.1456451416016', '-6.18269348144531', '36.9806594848633'), ('399', null, null, null, null, '1', 'Romania', null, null, '20.2699699401855', '48.2669525146484', '29.6910572052002', '43.6272964477539'), ('400', null, null, null, null, '1', 'Serbia', null, null, '18.8170185089111', '46.1813926696777', '23.0049991607666', '41.8558235168457'), ('401', null, null, null, null, '1', 'Slovakia', null, null, '16.8477478027344', '49.6031723022461', '22.5704460144043', '47.7281036376953'), ('402', null, null, null, null, '1', 'Slovenia', null, null, '13.3830814361572', '46.8779220581055', '16.5660037994385', '45.4131317138672'), ('403', null, null, null, null, '1', 'Spain', null, null, '-18.169641494751', '43.7917251586914', '4.31538963317871', '27.6388168334961'), ('404', null, null, null, null, '1', 'Sweden', null, null, '11.1186923980713', '69.0625076293945', '24.1608924865723', '55.3371047973633'), ('405', null, null, null, null, '1', 'Switzerland', null, null, '5.95747137069702', '47.8053359985352', '10.491473197937', '45.8256874084473'), ('406', null, null, null, null, '1', 'Ukraine', null, null, '22.128885269165', '52.3693695068359', '40.2073974609375', '44.3904075622559'), ('407', null, null, null, null, '1', 'United Kingdom', null, null, '-8.62355613708496', '60.8458099365234', '1.75900018215179', '49.9061889648438'), ('408', null, null, null, null, '1', 'Algeria', null, null, '-8.67386913299561', '37.0937271118164', '11.979549407959', '18.9600257873535'), ('409', null, null, null, null, '1', 'Angola', null, null, '11.679217338562', '-4.3768253326416', '24.0821228027344', '-18.0420780181885'), ('410', null, null, null, null, '1', 'Benin', null, null, '0.774574935436249', '12.4183483123779', '3.85170125961304', '6.22574710845947'), ('411', null, null, null, null, '1', 'Botswana', null, null, '19.999532699585', '-17.7808094024658', '29.3607845306396', '-26.9072494506836'), ('412', null, null, null, null, '1', 'Burkina Faso', null, null, '-5.51891660690308', '15.082594871521', '2.40539526939392', '9.40110683441162'), ('413', null, null, null, null, '1', 'Burundi', null, null, '28.9930572509766', '-2.31012272834778', '30.8477325439453', '-4.46571350097656'), ('414', null, null, null, null, '1', 'Cameroon', null, null, '8.49476146697998', '13.0780572891235', '16.1921195983887', '1.65254783630371'), ('415', null, null, null, null, '1', 'Central African Republic', null, null, '14.4200954437256', '11.0075702667236', '27.4634246826172', '2.22051358222961'), ('416', null, null, null, null, '1', 'Chad', null, null, '13.4734735488892', '23.4503726959229', '24.00266456604', '7.44106721878052'), ('417', null, null, null, null, '1', 'Congo', null, null, '11.2050075531006', '3.70308232307434', '18.6498413085938', '-5.02722358703613'), ('418', null, null, null, null, '1', 'Democratic Republic of the Congo', null, null, '12.2041425704956', '5.38609886169434', '31.3059139251709', '-13.4556760787964'), ('419', null, null, null, null, '1', 'Djibouti', null, null, '41.7734680175781', '12.7068347930908', '43.4169769287109', '10.9099159240723'), ('420', null, null, null, null, '1', 'Egypt', null, null, '24.6981086730957', '31.6673374176025', '35.7948684692383', '21.7253856658936'), ('421', null, null, null, null, '1', 'Equatorial Guinea', null, null, '9.34686374664307', '2.34698939323425', '11.3357257843018', '0.920859932899475'), ('422', null, null, null, null, '1', 'Eritrea', null, null, '36.4387741088867', '18.0030860900879', '43.1346473693848', '12.3595533370972'), ('423', null, null, null, null, '1', 'Ethiopia', null, null, '32.9999351501465', '14.8937511444092', '47.9861831665039', '3.40242171287537'), ('424', null, null, null, null, '1', 'Gabon', null, null, '8.69546985626221', '2.32261228561401', '14.5023488998413', '-3.97880625724792'), ('425', null, null, null, null, '1', 'Gambia', null, null, '-16.8250827789307', '13.8265724182129', '-13.7977914810181', '13.0642509460449'), ('426', null, null, null, null, '1', 'Ghana', null, null, '-3.25542044639587', '11.1733026504517', '1.19178116321564', '4.73672246932983'), ('427', null, null, null, null, '1', 'Guinea', null, null, '-14.9266204833984', '12.6762218475342', '-7.64107036590576', '7.19355249404907'), ('428', null, null, null, null, '1', 'Guinea-Bissau', null, null, '-16.7175369262695', '12.6807909011841', '-13.6365203857422', '10.9242639541626'), ('429', null, null, null, null, '1', 'Ivory Coast', null, null, '-8.59930324554443', '10.7366437911987', '-2.49489665031433', '4.35706615447998'), ('430', null, null, null, null, '1', 'Kenya', null, null, '33.9088516235352', '5.01993894577026', '41.8990821838379', '-4.67804765701294'), ('431', null, null, null, null, '1', 'Lesotho', null, null, '27.0290660858154', '-28.5720558166504', '29.465763092041', '-30.668966293335'), ('432', null, null, null, null, '1', 'Liberia', null, null, '-11.4920845031738', '8.55179214477539', '-7.3651123046875', '4.35305643081665'), ('433', null, null, null, null, '1', 'Libya', null, null, '9.38701820373535', '33.1690063476562', '25.1506156921387', '19.5080413818359'), ('434', null, null, null, null, '1', 'Madagascar', null, null, '43.2248687744141', '-11.9454317092896', '50.4837875366211', '-25.6089553833008'), ('435', null, null, null, null, '1', 'Malawi', null, null, '32.673942565918', '-9.36753940582275', '35.9168281555176', '-17.1250019073486'), ('436', null, null, null, null, '1', 'Mali', null, null, '-12.2426156997681', '25.0000057220459', '4.2449688911438', '10.1595115661621'), ('437', null, null, null, null, '1', 'Mauritania', null, null, '-17.0665245056152', '27.2980766296387', '-4.82767343521118', '14.7155456542969'), ('438', null, null, null, null, '1', 'Morocco', null, null, '-13.1685876846313', '35.9280319213867', '-0.991749882698059', '27.6621112823486'), ('439', null, null, null, null, '1', 'Mozambique', null, null, '30.2173156738281', '-10.4718818664551', '40.8430023193359', '-26.868688583374'), ('440', null, null, null, null, '1', 'Namibia', null, null, '11.7156286239624', '-16.9598903656006', '25.2567043304443', '-28.9714336395264'), ('441', null, null, null, null, '1', 'Niger', null, null, '0.166249975562096', '23.5250282287598', '15.995644569397', '11.6969738006592'), ('442', null, null, null, null, '1', 'Nigeria', null, null, '2.66843175888062', '13.8920087814331', '14.6800746917725', '4.27714347839355'), ('443', null, null, null, null, '1', 'Rwanda', null, null, '28.8567905426025', '-1.05348086357117', '30.8959617614746', '-2.84067940711975'), ('444', null, null, null, null, '1', 'Senegal', null, null, '-17.5352382659912', '16.6916351318359', '-11.3558855056763', '12.3072738647461'), ('445', null, null, null, null, '1', 'Sierra Leone', null, null, '-13.3076324462891', '10.0000009536743', '-10.284236907959', '6.92961025238037'), ('446', null, null, null, null, '1', 'Somalia', null, null, '40.9865875244141', '11.9791669845581', '51.4126434326172', '-1.67486822605133'), ('447', null, null, null, null, '1', 'South Africa', null, null, '16.4580173492432', '-22.1266098022461', '32.8959770202637', '-34.8398323059082'), ('448', null, null, null, null, '1', 'Sudan', null, null, '21.8389434814453', '23.1468925476074', '38.5800361633301', '3.48638963699341'), ('449', null, null, null, null, '1', 'Swaziland', null, null, '30.7941036224365', '-25.7196445465088', '32.137264251709', '-27.3171043395996'), ('450', null, null, null, null, '1', 'Tanzania', null, null, '29.3271656036377', '-0.99073588848114', '40.4432258605957', '-11.7456970214844'), ('451', null, null, null, null, '1', 'Togo', null, null, '-0.147324025630951', '11.1389780044556', '1.80669319629669', '6.10441637039185'), ('452', null, null, null, null, '1', 'Tunisia', null, null, '7.52483224868774', '37.5439224243164', '11.5982789993286', '30.2404136657715'), ('453', null, null, null, null, '1', 'Uganda', null, null, '29.5732498168945', '4.21442794799805', '35.0360565185547', '-1.48405015468597'), ('454', null, null, null, null, '1', 'Western Sahara', null, null, '-17.1031856536865', '27.669677734375', '-8.67027473449707', '20.7741546630859'), ('455', null, null, null, null, '1', 'Zambia', null, null, '21.9993686676025', '-8.22435855865479', '33.7057113647461', '-18.079475402832'), ('456', null, null, null, null, '1', 'Zimbabwe', null, null, '25.237024307251', '-15.6088333129883', '33.0563125610352', '-22.4177417755127'), ('457', null, null, null, null, '1', 'Afghanistan', null, null, '60.4784355163574', '38.4834251403809', '74.8794631958008', '29.3774700164795'), ('458', null, null, null, null, '1', 'Armenia', null, null, '43.4497756958008', '41.3018379211426', '49.4783973693848', '38.3970527648926'), ('459', null, null, null, null, '1', 'Azerbaijan', null, null, '44.7741088867188', '41.905647277832', '50.3700904846191', '38.8201866149902'), ('460', null, null, null, null, '1', 'Georgia', null, null, '40.0101318359375', '43.5865020751953', '46.7259750366211', '41.0531921386719'), ('461', null, null, null, null, '1', 'Iran', null, null, '44.0472717285156', '39.777229309082', '63.3174781799316', '25.064079284668'), ('462', null, null, null, null, '1', 'Iraq', null, null, '38.7958831787109', '37.3780364990234', '48.5759201049805', '29.0694427490234'), ('463', null, null, null, null, '1', 'Israel', null, null, '34.2304420471191', '33.3401412963867', '35.8768081665039', '29.4966354370117'), ('464', null, null, null, null, '1', 'Jordan', null, null, '34.9599914550781', '33.3676719665527', '39.3011741638184', '29.185884475708'), ('465', null, null, null, null, '1', 'Kuwait', null, null, '46.555549621582', '30.095947265625', '48.4314804077148', '28.5246086120605'), ('466', null, null, null, null, '1', 'Lebanon', null, null, '35.1142730712891', '34.6914253234863', '36.6391983032227', '33.0538558959961'), ('467', null, null, null, null, '1', 'Oman', null, null, '51.8819961547852', '26.387975692749', '59.8365859985352', '16.6457462310791'), ('468', null, null, null, null, '1', 'Pakistan', null, null, '60.8786087036133', '37.0970039367676', '77.8409271240234', '23.7867183685303'), ('469', null, null, null, null, '1', 'Qatar', null, null, '50.7572135925293', '26.1547241210938', '51.636646270752', '24.4829406738281'), ('470', null, null, null, null, '1', 'Saudi Arabia', null, null, '34.4956855773926', '32.1583404541016', '55.6665878295898', '15.6142482757568'), ('471', null, null, null, null, '1', 'Syria', null, null, '35.7272148132324', '37.3191452026367', '42.3850364685059', '32.3106575012207'), ('472', null, null, null, null, '1', 'Tajikistan', null, null, '67.3871231079102', '41.0422592163086', '75.1372299194336', '36.674129486084'), ('473', null, null, null, null, '1', 'Turkey', null, null, '25.6684989929199', '42.1076202392578', '44.8350028991699', '35.8154106140137'), ('474', null, null, null, null, '1', 'Turkmenistan', null, null, '46.6846046447754', '47.0156173706055', '66.6843109130859', '35.1410789489746'), ('475', null, null, null, null, '1', 'United Arab Emirates', null, null, '51.583324432373', '26.0841617584229', '56.381664276123', '22.6333274841309'), ('476', null, null, null, null, '1', 'Yemen', null, null, '42.5325241088867', '19.0023365020752', '54.5305328369141', '12.1110811233521'), ('477', null, null, null, null, '1', 'Kazakhstan', null, null, '46.4918518066406', '55.4512023925781', '87.3126831054688', '40.9363288879395'), ('478', null, null, null, null, '1', 'Kyrgyzstan', null, null, '69.2765960693359', '43.2382278442383', '80.2831802368164', '39.1728248596191'), ('479', null, null, null, null, '1', 'Mongolia', null, null, '87.7496490478516', '52.1542549133301', '119.924324035645', '41.5676307678223'), ('480', null, null, null, null, '1', 'Russia', null, null, '-19.25', '81.8573760986328', '180', '41.1888580322266'), ('481', null, null, null, null, '1', 'Uzbekistan', null, null, '55.9966316223145', '45.575008392334', '73.1322860717773', '37.1844367980957'), ('482', null, null, null, null, '1', 'Bangladesh', null, null, '88.0283279418945', '26.6319484710693', '92.6736831665039', '20.7433319091797'), ('483', null, null, null, null, '1', 'Brunei', null, null, '114.071434020996', '5.04716777801514', '115.35945892334', '4.00308227539062'), ('484', null, null, null, null, '1', 'Buthan', null, null, '88.7597122192383', '28.3237800598145', '92.1252059936523', '26.7076377868652'), ('485', null, null, null, null, '1', 'Cambodia', null, null, '102.339981079102', '14.6864185333252', '107.627738952637', '10.4090814590454'), ('486', null, null, null, null, '1', 'China', null, null, '73.5576782226562', '53.5608673095703', '134.773941040039', '15.7754144668579'), ('487', null, null, null, null, '1', 'India', null, null, '68.1866760253906', '35.5042304992676', '97.4033126831055', '6.74713850021362'), ('488', null, null, null, null, '1', 'Indonesia', null, null, '95.0093231201172', '5.90441751480103', '141.021835327148', '-10.9418621063232'), ('489', null, null, null, null, '1', 'Japan', null, null, '122.938522338867', '45.5231475830078', '145.820907592773', '24.2494697570801'), ('490', null, null, null, null, '1', 'Taiwan', null, null, '119.534683227539', '25.2982521057129', '122.000457763672', '21.9018039703369'), ('491', null, null, null, null, '1', 'Laos', null, null, '100.093048095703', '22.5003910064697', '107.697036743164', '13.9100255966187'), ('492', null, null, null, null, '1', 'Malaysia', null, null, '99.643440246582', '7.36341762542725', '119.267517089844', '0.855221927165985'), ('493', null, null, null, null, '1', 'Myanmar', null, null, '92.1892700195312', '28.5432510375977', '101.176795959473', '9.78458118438721'), ('494', null, null, null, null, '1', 'Nepal', null, null, '80.0562591552734', '30.4333934783936', '88.1993408203125', '26.3567199707031'), ('495', null, null, null, null, '1', 'North Korea', null, null, '124.315872192383', '43.0060615539551', '130.674896240234', '37.6733245849609'), ('496', null, null, null, null, '1', 'Philippines', null, null, '116.931549072266', '21.1206130981445', '126.601531982422', '4.64330530166626'), ('497', null, null, null, null, '1', 'Thailand', null, null, '97.3456268310547', '20.4631977081299', '105.63939666748', '5.60999917984009'), ('498', null, null, null, null, '1', 'South Korea', null, null, '125.887100219727', '38.6124534606934', '129.584686279297', '33.1909408569336'), ('499', null, null, null, null, '1', 'Sri Lanka', null, null, '79.6529083251953', '9.8313627243042', '81.8812942504883', '5.916832447052'), ('500', null, null, null, null, '1', 'Viet Nam', null, null, '102.148216247559', '23.3888378143311', '109.464653015137', '8.55960941314697'), ('501', null, null, null, null, '1', 'Australia', null, null, '112.91104888916', '-10.0628032684326', '153.639282226562', '-43.6439743041992'), ('502', null, null, null, null, '1', 'New Zealand', null, null, '165.996170043945', '-29.2410945892334', '176.275848388672', '-52.6075859069824'), ('503', null, null, null, null, '1', 'Papua New Guinea', null, null, '140.842849731445', '-1.31863880157471', '155.963470458984', '-11.657862663269');
COMMIT;

-- ----------------------------
--  Table structure for `o_station`
-- ----------------------------
DROP TABLE IF EXISTS `o_station`;
CREATE TABLE `o_station` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '序号',
  `name` varchar(255) DEFAULT NULL COMMENT '名称',
  `code` varchar(10) DEFAULT NULL COMMENT '冠字',
  `topology` int(11) DEFAULT NULL,
  `tel` varchar(255) DEFAULT NULL COMMENT '联系电话',
  `longitude` float(10,2) DEFAULT NULL COMMENT '经度',
  `latitude` float(10,2) DEFAULT NULL COMMENT '纬度',
  `status` int(11) DEFAULT NULL COMMENT '状态',
  `tm_create` datetime DEFAULT NULL COMMENT '记录建立时间',
  `tm_modify` datetime DEFAULT NULL COMMENT '最后修改时间',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `o_station`
-- ----------------------------
BEGIN;
INSERT INTO `o_station` VALUES ('1', 'name111', 'code1', '13', '', '0.00', '0.00', '1', null, '2012-01-16 11:19:51', 'ccbak'), ('2', 'name2', 'code2', '14', '', '0.00', '0.00', '1', null, '2011-12-21 14:52:30', null), ('3', 'name3', 'code3', '11', '', '0.00', '0.00', '1', null, '2011-12-21 14:51:47', null), ('4', 'name4', 'code4', '11', '', '0.00', '0.00', '1', null, '2011-03-28 10:41:24', null), ('5', 'name5', 'code5', '11', '', '0.00', '0.00', '1', null, '2011-12-21 14:56:27', null), ('6', 'name6', 'code6', '11', '', '0.00', '0.00', '1', null, '2011-12-21 14:58:01', null), ('7', 'name7', 'code7', '11', '', '0.00', '0.00', '1', null, '2011-02-15 16:41:22', null), ('8', 'name8', 'code8', '11', '', '0.00', '0.00', '1', null, '2011-02-17 13:32:33', null), ('9', 'name9', 'code9', '11', '', '0.00', '0.00', '1', null, '2011-02-17 11:27:27', null), ('10', 'name10', 'code10', '11', '', '0.00', '0.00', '1', null, '2011-02-15 16:42:07', null), ('11', 'name11', 'code11', '11', '', '0.00', '0.00', '1', null, '2011-02-15 16:42:07', null), ('12', 'name12', 'code12', '11', '', '0.00', '0.00', '1', null, '2011-02-15 16:42:07', null), ('13', 'name13', 'code13', '11', '', '0.00', '0.00', '1', null, '2011-02-15 16:42:07', null), ('14', 'name14', 'code14', '11', '', '0.00', '0.00', '1', null, '2011-02-15 16:42:07', null), ('15', 'name15', 'code15', '11', '', '0.00', '0.00', '1', null, '2011-02-15 16:42:07', null), ('16', 'name16', 'code16', '11', '', '0.00', '0.00', '1', null, '2011-02-15 16:41:49', null), ('17', 'name17', 'code17', '11', '', '0.00', '0.00', '1', null, '2011-02-15 16:41:49', null), ('18', 'name18', 'code18', '11', '', '0.00', '0.00', '1', null, '2011-02-15 16:41:49', null), ('19', 'name19', 'code19', null, '', '0.00', '0.00', '1', null, null, null), ('20', 'name20', 'code20', null, '', '0.00', '0.00', '1', null, null, null), ('21', 'name21', 'code21', '11', '', '0.00', '0.00', '1', null, '2011-02-17 13:49:07', null), ('22', 'name22', 'code22', '14', '', '0.00', '0.00', '1', null, '2011-03-28 10:44:21', null), ('23', 'name23', 'code23', '14', '', '0.00', '0.00', '1', null, '2011-03-28 10:44:21', null), ('24', 'name24', 'code24', '14', '', '0.00', '0.00', '1', null, '2011-03-28 10:44:21', null), ('25', 'name25', 'code25', '14', '', '0.00', '0.00', '1', null, '2011-03-28 10:44:21', null), ('26', 'name26', 'code26', '14', '', '0.00', '0.00', '1', null, '2011-03-28 10:44:21', null), ('27', 'name27', 'code27', '14', '', '0.00', '0.00', '1', null, '2011-03-28 10:44:21', null), ('28', 'name28', 'code28', '14', '', '0.00', '0.00', '1', null, '2011-03-28 10:44:21', null), ('29', 'name29', 'code29', '14', '', '0.00', '0.00', '1', null, '2011-03-28 10:44:21', null), ('30', 'name30', 'code30', '14', '', '0.00', '0.00', '1', null, '2011-03-28 10:44:21', null), ('31', 'name31', 'code31', '14', '', '0.00', '0.00', '1', null, '2011-03-28 10:44:21', null), ('32', 'name32', 'code32', '14', '', '0.00', '0.00', '1', null, '2011-03-28 10:44:21', null), ('33', 'name33', 'code33', '14', '', '0.00', '0.00', '1', null, '2011-03-28 10:44:21', null), ('34', 'name34', 'code34', '14', '', '0.00', '0.00', '1', null, '2011-03-28 10:44:21', null), ('35', 'name35', 'code35', '14', '', '0.00', '0.00', '1', null, '2011-03-28 10:44:21', null), ('36', 'name36', 'code36', '14', '', '0.00', '0.00', '1', null, '2011-03-28 10:44:21', null), ('37', 'name37', 'code37', '14', '', '0.00', '0.00', '1', null, '2011-03-28 10:44:21', null), ('38', 'name38', 'code38', '14', '', '0.00', '0.00', '1', null, '2011-03-28 10:44:21', null), ('39', 'name39', 'code39', '14', '', '0.00', '0.00', '1', null, '2011-03-28 10:44:21', null), ('40', 'name40', 'code40', '14', '', '0.00', '0.00', '1', null, '2011-03-28 10:44:21', null);
COMMIT;

-- ----------------------------
--  Table structure for `o_status`
-- ----------------------------
DROP TABLE IF EXISTS `o_status`;
CREATE TABLE `o_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mid` int(11) DEFAULT NULL COMMENT '设备型号序号',
  `dispalyname` varchar(255) DEFAULT NULL,
  `oid` varchar(255) DEFAULT NULL COMMENT 'snmp节点oid',
  `classname` varchar(255) DEFAULT NULL COMMENT '状态类名',
  `propname` varchar(255) DEFAULT NULL COMMENT '属性名',
  `cnname` varchar(255) DEFAULT NULL COMMENT '中文名称',
  `meaning` varchar(255) DEFAULT NULL COMMENT '含义',
  `limit_up` decimal(10,2) DEFAULT NULL COMMENT '参数上限',
  `limit_down` decimal(10,2) DEFAULT NULL COMMENT '参数下限',
  `cycle_query` int(11) DEFAULT NULL COMMENT '轮询周期(秒)',
  `cycle_record` int(11) DEFAULT NULL COMMENT '记录周期(秒)',
  `spanval` decimal(10,2) DEFAULT NULL COMMENT '增量值',
  `uploadtype` varchar(50) DEFAULT NULL COMMENT '上报方式',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `tm_create` datetime DEFAULT NULL COMMENT '创建时间',
  `tm_modify` datetime DEFAULT NULL COMMENT '修改时间',
  `alarmlevel` varchar(50) DEFAULT NULL COMMENT '报警级别',
  `ordernum` int(11) DEFAULT NULL COMMENT '显示顺序',
  `showflag` int(11) NOT NULL DEFAULT '0' COMMENT '是否显示,0表示不显示,1表示显示',
  `unit` varchar(50) DEFAULT NULL COMMENT '计量单位',
  `coefficient` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=240 DEFAULT CHARSET=utf8 COMMENT='状态上报信息表';

-- ----------------------------
--  Records of `o_status`
-- ----------------------------
BEGIN;
INSERT INTO `o_status` VALUES ('5', '1', '小站收坏帧增量', '1.3.6.1.4.1.727.7.2.20.2.1.12.1', null, 'RxBadFrame1', '广域口1坏帧数', null, '10.00', null, '30', '3600', '-1.00', '', null, null, '2011-11-28 15:17:46', '4', '5', '1', null, null), ('9', '3', 'RxEbN0', null, null, null, null, '', '1.00', null, '60', '600', null, null, null, null, null, null, null, '0', null, null), ('10', '3', 'EbN0Offset', null, null, null, null, null, '3.00', null, '600', '600', null, null, null, null, null, null, null, '0', null, null), ('19', '3', 'MoUnitFault', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '0', null, null), ('20', '3', 'MoTxFault', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '0', null, null), ('21', '3', 'MoRxFault', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '0', null, null), ('22', '3', 'MoIPModule', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '0', null, null), ('26', '5', 'Modem温度', '1.3.6.1.4.1.6247.24.1.1.1.2.0', 'ODevice', 'ModemTemp', 'Modem温度', null, null, null, '0', null, '-1.00', '', null, null, '2011-11-05 10:10:06', null, '5', '1', '℃', null), ('27', '5', '小站收Eb/N0', '1.3.6.1.4.1.6247.24.1.3.2.5.0', 'ODevice', 'MoEbN0', '接收Eb/N0', null, '12.00', '7.00', '5', null, '-1.00', null, null, null, '2011-11-05 12:00:17', '4', '1', '1', 'dB', '10'), ('28', '8', '温度值:', '1.3.6.1.4.1.34672.1.0', null, 'Temperature', null, null, '30.00', '5.00', '5', '4', '-1.00', null, null, '2011-05-13 09:48:01', '2011-10-28 09:20:31', '3', '1', '1', '℃', null), ('29', '8', '湿度值:', '1.3.6.1.4.1.34672.2.0', null, 'Humidity', null, null, '50.00', '5.00', '5', '5', '-1.00', null, null, '2011-05-13 09:53:56', '2011-10-28 09:21:23', '3', '2', '1', '%', null), ('30', '8', '露点值:', '1.3.6.1.4.1.34672.3.0', null, 'DewPoint', null, null, '100.00', '0.00', '5', '5', '-1.00', null, null, '2011-05-13 09:53:56', '2011-11-07 08:27:47', '1', '3', '1', null, null), ('31', '8', '市电值:', '1.3.6.1.4.1.34672.4.0', null, 'VoltageA', null, null, '1023.00', '0.00', '5', null, '-1.00', null, null, '2011-05-13 09:53:56', '2011-10-28 09:55:19', '3', '4', '1', 'V', '4.096'), ('32', '8', 'UPS电压值:', '1.3.6.1.4.1.34672.5.0', null, 'VoltageB', null, null, '1023.00', '0.00', '5', null, '-1.00', null, null, '2011-05-13 09:53:56', '2011-10-28 09:27:46', '3', '5', '1', 'V', '4.096'), ('33', '6', 'ODU温度', 'RMS', null, 'UTMP', 'ODU温度', null, '50.00', null, '5', '3600', '-1.00', null, null, '2011-09-02 09:27:28', '2011-11-05 15:44:38', '3', '1', '1', 'dBm', null), ('38', '7', '主站收 Eb/N0', '1.3.6.1.4.1.6247.27.1.3.4.1.1.7.1', '', 'EbN01', '端口1 Eb/N0', '', '12.00', '7.00', '5', '60', '-1.00', '', null, '2011-10-09 14:07:49', '2011-12-15 13:30:22', '4', '1', '1', 'dB', '10'), ('39', '7', '主站收 Eb/N0', '1.3.6.1.4.1.6247.27.1.3.4.1.1.7.2', null, 'EbN02', '端口2 Eb/N0', null, '12.00', '7.00', '5', '60', '-1.00', null, null, '2011-10-09 14:09:54', '2011-12-15 13:30:22', '4', '7', '1', 'dB', '10'), ('40', '5', '主站收Eb/N0', null, '', 'V_EbN0', 'V_EbN0', null, null, null, null, null, '-1.00', '', null, '2011-10-11 09:19:37', '2011-12-22 09:37:32', '', null, '0', 'dB', null), ('44', '1', '主站收坏帧增量', '', '', 'V_BadFrame', 'V_BadFrame', null, null, null, null, null, null, null, null, '2011-10-11 13:36:25', '2011-12-22 09:38:08', '', null, '0', '', null), ('46', '5', '接收电平', '1.3.6.1.4.1.6247.24.1.3.2.4.0', 'ODevice', 'MoRSL', '接收电平', null, null, null, '0', null, '-1.00', null, null, null, '2011-11-05 10:10:06', null, '2', '1', 'dBm', null), ('47', '5', '接收频偏', '1.3.6.1.4.1.6247.24.1.3.2.3.0', 'ODevice', 'MoFreqOffset', '接收频偏', null, null, null, '0', null, '-1.00', null, null, null, '2011-11-05 10:10:06', null, '3', '1', 'KHz', '1000'), ('48', '5', '修正误码率', '1.3.6.1.4.1.6247.24.1.3.2.1.0', 'ODevice', 'MoCBER', '修正误码率', null, null, null, '0', null, '-1.00', null, null, null, '2011-11-05 10:10:06', null, '4', '1', '10E-9', '10'), ('49', '1', '广域口1状态', '1.3.6.1.4.1.727.7.2.20.2.1.7.1', null, 'WanStatus1', '广域口1状态', null, null, null, null, null, null, null, null, '2011-10-26 08:50:00', '2011-11-28 15:17:46', null, '4', '1', '', null), ('50', '1', '广域口301状态', '1.3.6.1.4.1.727.7.2.20.2.1.7.301', null, 'WanStatus301', '广域口301状态', null, null, null, null, null, null, null, null, '2011-10-26 08:55:09', '2011-11-28 15:17:46', null, '7', '1', null, null), ('51', '1', '广域口302状态', '1.3.6.1.4.1.727.7.2.20.2.1.7.302', null, 'WanStatus302', '广域口302状态', null, null, null, null, null, null, null, null, '2011-10-26 08:58:15', '2011-11-28 15:17:46', null, '10', '1', null, null), ('52', '1', '广域口301坏帧数', '1.3.6.1.4.1.727.7.2.20.2.1.12.301', null, 'RxBadFrame301', '广域口301坏帧数', null, null, null, null, null, null, null, null, '2011-10-26 09:00:52', '2011-11-28 15:17:46', null, '8', '1', null, null), ('53', '1', '复用器名称', '1.3.6.1.4.1.727.7.2.1.3.0', null, 'SysName', '复用器名称', null, null, null, null, null, null, null, null, '2011-10-26 09:00:52', '2011-10-26 09:13:12', null, '1', '1', null, null), ('54', '1', '广域口302坏帧数', '1.3.6.1.4.1.727.7.2.20.2.1.12.302', null, 'RxBadFrame302', '广域口302坏帧数', null, null, null, null, null, null, null, null, '2011-10-26 09:07:41', '2011-11-28 15:17:46', null, '11', '1', null, null), ('55', '1', 'PVC1状态', '1.3.6.1.4.1.727.7.2.20.6.1.6.1', null, 'PvcStatus1', 'PVC1状态', null, null, null, null, null, null, null, null, '2011-10-26 09:16:46', '2011-11-28 14:42:22', null, '14', '1', null, null), ('56', '1', 'PVC1的DLCI号', '1.3.6.1.4.1.727.7.2.20.6.1.21.1', null, 'PvcDlci1', 'PVC1的DLCI号', null, null, null, null, null, null, null, null, '2011-10-26 09:18:41', '2011-11-28 14:42:22', null, '15', '1', null, null), ('57', '1', 'PVC1对端名称', '1.3.6.1.4.1.727.7.2.20.6.1.37.1', null, 'PvcDestName1', 'PVC1对端名称', null, null, null, null, null, null, null, null, '2011-10-26 09:22:17', '2011-11-28 14:42:22', null, '16', '1', null, null), ('58', '1', 'PVC2状态', '1.3.6.1.4.1.727.7.2.20.6.1.6.2', null, 'PvcStatus2', 'PVC2状态', null, null, null, null, null, null, null, null, '2011-10-26 09:25:25', '2011-11-28 14:42:22', null, '18', '1', null, null), ('59', '1', 'PVC2的DLCI号', '1.3.6.1.4.1.727.7.2.20.6.1.21.2', null, 'PvcDlci2', 'PVC2的DLCI号', null, null, null, null, null, null, null, null, '2011-10-26 09:26:06', '2011-11-28 14:42:22', null, '19', '1', null, null), ('60', '1', 'PVC2对端名称', '1.3.6.1.4.1.727.7.2.20.6.1.37.2', null, 'PvcDestName2', 'PVC2对端名称', null, null, null, null, null, null, null, null, '2011-10-26 09:26:48', '2011-11-28 14:42:22', null, '20', '1', null, null), ('61', '1', '以太网口1发流量', '1.3.6.1.4.1.727.7.2.20.3.1.9.1', null, 'LanPeakTx1-kbps', '以太网口1发流量', null, null, null, null, null, null, null, null, '2011-10-26 10:35:07', '2011-11-28 14:45:08', null, '24', '1', null, null), ('62', '1', '以太网口2发流量', '1.3.6.1.4.1.727.7.2.20.3.1.9.2', null, 'LanPeakTx2-kbps', '以太网口2发流量', null, null, null, null, null, null, null, null, '2011-10-26 10:39:45', '2011-11-28 14:45:51', null, '26', '1', null, null), ('63', '1', '以太网口1收流量', '1.3.6.1.4.1.727.7.2.20.3.1.10.1', null, 'LanPeakRx1-kbps', '以太网口1收流量', null, null, null, null, null, null, null, null, '2011-10-26 10:40:52', '2011-11-28 14:44:51', null, '23', '1', null, null), ('64', '1', '以太网口2收流量', '1.3.6.1.4.1.727.7.2.20.3.1.10.2', null, 'LanPeakRx2-kbps', '以太网口2收流量', null, null, null, null, null, null, null, null, '2011-10-26 10:41:49', '2011-11-28 14:45:51', null, '27', '1', null, null), ('65', '1', '单机口1状态', '1.3.6.1.4.1.727.7.2.20.10.1.3.101', null, 'VceState101', '单机口1状态', '1:IDLE', null, null, null, null, null, null, null, '2011-10-26 10:43:58', '2011-11-28 14:45:51', null, '30', '1', null, null), ('66', '1', '单机口2状态', '1.3.6.1.4.1.727.7.2.20.10.1.3.102', null, 'VceState102', '单机口2状态', '1:IDLE', null, null, null, null, null, null, null, '2011-10-26 10:47:57', '2011-11-28 14:45:51', null, '31', '1', null, null), ('67', '1', '单机口3状态', '1.3.6.1.4.1.727.7.2.20.10.1.3.103', null, 'VceState103', '单机口3状态', null, null, null, null, null, null, null, null, '2011-10-26 10:48:25', '2011-11-28 14:45:51', null, '32', '1', null, null), ('68', '1', '单机口4状态', '1.3.6.1.4.1.727.7.2.20.10.1.3.104', null, 'VceState104', '单机口4状态', null, null, null, null, null, null, null, null, '2011-10-26 10:48:52', '2011-11-28 14:45:51', null, '33', '1', null, null), ('69', '1', '中继口1状态', '1.3.6.1.4.1.727.7.2.20.10.1.3.201', null, 'VceState201', '中继口1状态', null, null, null, null, null, null, null, null, '2011-10-26 10:50:05', '2011-11-28 14:45:51', null, '36', '1', null, null), ('70', '1', '中继口2状态', '1.3.6.1.4.1.727.7.2.20.10.1.3.202', null, 'VceState202', '中继口2状态', null, null, null, null, null, null, null, null, '2011-10-26 10:50:48', '2011-11-28 14:45:51', null, '37', '1', null, null), ('71', '1', '中继口3状态', '1.3.6.1.4.1.727.7.2.20.10.1.3.203', null, 'VceState203', '中继口3状态', null, null, null, null, null, null, null, null, '2011-10-26 10:51:18', '2011-11-28 14:45:51', null, '38', '1', null, null), ('72', '1', '中继口4状态', '1.3.6.1.4.1.727.7.2.20.10.1.3.204', null, 'VceState204', '中继口4状态', null, null, null, null, null, null, null, null, '2011-10-26 10:51:50', '2011-11-28 14:45:51', null, '39', '1', null, null), ('73', '6', 'ODU功率', 'RMS', null, 'POWR', 'ODU功率', null, '28.00', null, '10', '3600', '-1.00', null, null, '2011-10-27 17:00:24', '2011-11-05 11:19:49', '3', '2', '1', 'dBm', null), ('74', '6', 'ODU报警', 'RAS', null, 'ALM', 'ODU报警', null, null, null, null, null, null, null, null, '2011-10-28 09:06:22', '2011-11-05 11:07:59', null, '3', '1', null, null), ('78', '16', '广域口2坏帧数', '1.3.6.1.4.1.727.7.2.20.2.1.12.4', null, 'RxBadFrame2', '广域口2坏帧数', null, null, null, null, null, null, null, null, '2011-11-02 13:08:00', '2011-11-18 14:31:08', null, '5', '1', null, null), ('79', '16', '复用器名称', '1.3.6.1.4.1.727.7.2.1.3.0', null, 'SysName', '复用器名称', null, null, null, null, null, null, null, null, '2011-11-02 13:11:31', '2011-10-26 09:13:12', null, '1', '1', null, null), ('80', '16', '广域口2状态', '1.3.6.1.4.1.727.7.2.20.2.1.7.4', null, 'WanStatus2', '广域口2状态', null, null, null, null, null, null, null, null, '2011-11-02 13:11:45', '2011-11-18 14:31:08', null, '4', '1', '', null), ('82', '16', '广域口201状态', '1.3.6.1.4.1.727.7.2.20.2.1.7.10', null, 'WanStatus201', '广域口201状态', null, null, null, null, null, null, null, null, '2011-11-02 13:12:12', '2011-11-28 15:09:11', null, '7', '1', null, null), ('83', '16', '广域口201坏帧数', '1.3.6.1.4.1.727.7.2.20.2.1.12.10', null, 'RxBadFrame201', '广域口201坏帧数', null, '10.00', null, '30', '3600', '-1.00', null, null, '2011-11-02 13:12:36', '2011-11-28 15:09:11', '4', '8', '1', null, null), ('84', '16', '广域口202状态', '1.3.6.1.4.1.727.7.2.20.2.1.7.11', null, 'WanStatus202', '广域口202状态', null, null, null, null, null, null, null, null, '2011-11-02 13:14:42', '2011-11-28 15:09:11', null, '10', '1', null, null), ('85', '16', '广域口202坏帧数', '1.3.6.1.4.1.727.7.2.20.2.1.12.11', null, 'RxBadFrame202', '广域口202坏帧数', '', '10.00', null, '30', '3600', '-1.00', null, null, '2011-11-02 13:14:54', '2011-11-28 15:09:11', '4', '11', '1', '', null), ('86', '16', 'PVC1状态', '1.3.6.1.4.1.727.7.2.20.6.1.6.1', null, 'PvcStatus1', 'PVC1状态', null, null, null, null, null, null, null, null, '2011-11-02 13:15:05', '2011-11-28 15:10:50', null, '14', '1', null, null), ('87', '16', 'PVC1的DLCI号', '1.3.6.1.4.1.727.7.2.20.6.1.21.1', null, 'PvcDlci1', 'PVC1的DLCI号', null, null, null, null, null, null, null, null, '2011-11-02 13:15:14', '2011-11-28 15:10:50', null, '15', '1', null, null), ('88', '16', 'PVC1对端名称', '1.3.6.1.4.1.727.7.2.20.6.1.37.1', null, 'PvcDestName1', 'PVC1对端名称', null, null, null, null, null, null, null, null, '2011-11-02 13:15:22', '2011-11-28 15:10:50', null, '16', '1', null, null), ('89', '16', 'PVC2状态', '1.3.6.1.4.1.727.7.2.20.6.1.6.2', null, 'PvcStatus2', 'PVC2状态', null, null, null, null, null, null, null, null, '2011-11-02 13:15:31', '2011-11-28 15:10:50', null, '18', '1', null, null), ('90', '16', 'PVC2的DLCI号', '1.3.6.1.4.1.727.7.2.20.6.1.21.2', null, 'PvcDlci2', 'PVC2的DLCI号', null, null, null, null, null, null, null, null, '2011-11-02 13:15:41', '2011-11-28 15:10:50', null, '19', '1', null, null), ('91', '16', 'PVC2对端名称', '1.3.6.1.4.1.727.7.2.20.6.1.37.2', null, 'PvcDestName2', 'PVC2对端名称', null, null, null, null, null, null, null, null, '2011-11-02 13:17:36', '2011-11-28 15:10:50', null, '20', '1', null, null), ('92', '16', '以太网口1发流量', '1.3.6.1.4.1.727.7.2.20.3.1.9.1', null, 'LanPeakTx1-kbps', '以太网口1发流量', null, null, null, null, null, null, null, null, '2011-11-02 13:17:51', '2011-11-28 15:10:50', null, '23', '1', null, null), ('93', '16', '以太网口1收流量', '1.3.6.1.4.1.727.7.2.20.3.1.10.1', null, 'LanPeakRx1-kbps', '以太网口1收流量', null, null, null, null, null, null, null, null, '2011-11-02 13:18:07', '2011-11-28 15:09:11', null, '24', '1', null, null), ('96', '7', '端口1 接收电平', '1.3.6.1.4.1.6247.27.1.3.4.1.1.6.1', null, 'MoRSL1', '端口1 接收电平', null, null, null, '5', null, '-1.00', null, null, '2011-11-02 14:50:39', '2011-11-04 12:51:09', null, '2', '1', 'dBm', null), ('97', '7', '端口1 接收频偏', '1.3.6.1.4.1.6247.27.1.3.4.1.1.5.1', null, 'MoFreqOffset1', '端口1 接收频偏', null, null, null, '5', null, '-1.00', null, null, '2011-11-02 14:50:48', '2011-11-04 12:51:09', null, '3', '1', 'KHz', '1000'), ('98', '7', '端口1 修正误码率', '1.3.6.1.4.1.6247.27.1.3.4.1.1.3.1', null, 'MoCBER1', '端口1 修正误码率', null, null, null, '5', null, '-1.00', null, null, '2011-11-02 14:50:57', '2011-12-15 13:28:18', null, '4', '1', '10E-9', null), ('99', '7', ' Modem温度', '1.3.6.1.4.1.6247.27.1.1.1.4.0', null, 'ModemTemp', 'Modem温度', null, null, null, '5', null, '-1.00', null, null, '2011-11-02 14:51:05', '2011-12-16 10:59:12', null, '33', '1', '℃', null), ('100', '7', '端口2 接收电平', '1.3.6.1.4.1.6247.27.1.3.4.1.1.6.2', null, 'MoRSL2', '端口2 接收电平', null, null, null, '5', null, '-1.00', null, null, '2011-11-02 15:12:16', '2011-11-28 14:30:08', null, '8', '1', 'dBm', null), ('101', '7', '端口2 接收频偏', '1.3.6.1.4.1.6247.27.1.3.4.1.1.5.2', null, 'MoFreqOffset2', '端口2 接收频偏', null, null, null, '5', null, '-1.00', null, null, '2011-11-02 15:12:48', '2011-11-28 14:30:08', null, '9', '1', 'KHz', '1000'), ('102', '7', '端口2 修正误码率', '1.3.6.1.4.1.6247.27.1.3.4.1.1.3.2', null, 'MoCBER2', '端口2 修正误码率', null, null, null, '5', null, '-1.00', null, null, '2011-11-02 15:13:26', '2011-12-15 13:28:18', null, '10', '1', '10E-9', null), ('104', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '0', null, null), ('204', '18', 'Modem温度', '1.3.6.1.4.1.6247.24.1.1.1.2.0', null, 'ModemTemp', 'Modem温度', null, null, null, '0', null, '-1.00', null, null, '2011-11-05 10:09:12', '2011-11-05 10:13:28', null, '5', '1', '℃', null), ('205', '18', '主站收Eb/N0', '1.3.6.1.4.1.6247.24.1.3.2.5.0', null, 'MoEbN0', '接收Eb/N0', null, null, null, '5', null, '-1.00', null, null, '2011-11-05 10:09:12', '2011-12-22 10:41:55', '4', '1', '1', 'dB', '10'), ('207', '18', '接收电平', '1.3.6.1.4.1.6247.24.1.3.2.4.0', null, 'MoRSL', '接收电平', null, null, null, '0', null, '-1.00', null, null, '2011-11-05 10:09:12', '2011-11-05 10:13:28', null, '2', '1', 'dBm', null), ('208', '18', '接收频偏', '1.3.6.1.4.1.6247.24.1.3.2.3.0', null, 'MoFreqOffset', '接收频偏', null, null, null, '0', null, '-1.00', null, null, '2011-11-05 10:09:12', '2011-11-05 10:13:28', null, '3', '1', 'KHz', '1000'), ('209', '18', '修正误码率', '1.3.6.1.4.1.6247.24.1.3.2.1.0', null, 'MoCBER', '修正误码率', null, null, null, '0', null, '-1.00', null, null, '2011-11-05 10:09:12', '2011-11-05 10:13:28', null, '4', '1', '10E-9', '10'), ('210', '18', '发射开关', '1.3.6.1.4.1.6247.24.1.2.2.11.0', null, 'B_TxIFState', '发射开关', null, null, null, '5', null, '0.50', null, null, '2011-11-28 10:23:44', '2011-11-28 12:16:40', null, '6', '1', null, null), ('211', '20', '复用器名称', '1.3.6.1.4.1.727.7.2.1.3.0', null, 'SysName', '复用器名称', null, null, null, null, null, null, null, null, '2011-11-28 15:42:13', '2011-10-26 09:13:12', null, '1', '1', null, null), ('212', '20', '主站收坏帧增量', '1.3.6.1.4.1.727.7.2.20.2.1.12.1', null, 'RxBadFrame1', '广域口1坏帧数', null, '10.00', null, '30', '3600', '-1.00', null, null, '2011-11-28 15:42:25', '2011-12-22 10:08:03', '4', '5', '1', null, null), ('219', '20', '广域口1状态', '1.3.6.1.4.1.727.7.2.20.2.1.7.1', null, 'WanStatus1', '广域口1状态', null, null, null, null, null, null, null, null, '2011-11-28 15:48:28', '2011-11-28 15:17:46', null, '4', '1', '', null), ('220', '20', 'PVC1状态', '1.3.6.1.4.1.727.7.2.20.6.1.6.1', null, 'PvcStatus1', 'PVC1状态', null, null, null, null, null, null, null, null, '2011-11-28 15:48:48', '2011-11-28 15:51:48', null, '8', '1', null, null), ('221', '20', 'PVC1的DLCI号', '1.3.6.1.4.1.727.7.2.20.6.1.21.1', null, 'PvcDlci1', 'PVC1的DLCI号', null, null, null, null, null, null, null, null, '2011-11-28 15:48:57', '2011-11-28 15:51:48', null, '9', '1', null, null), ('222', '20', 'PVC1对端名称', '1.3.6.1.4.1.727.7.2.20.6.1.37.1', null, 'PvcDestName1', 'PVC1对端名称', null, null, null, null, null, null, null, null, '2011-11-28 15:49:07', '2011-11-28 15:51:48', null, '10', '1', null, null), ('223', '20', 'PVC2状态', '1.3.6.1.4.1.727.7.2.20.6.1.6.2', null, 'PvcStatus2', 'PVC2状态', null, null, null, null, null, null, null, null, '2011-11-28 15:49:15', '2011-11-28 15:51:48', null, '12', '1', null, null), ('224', '20', 'PVC2对端名称', '1.3.6.1.4.1.727.7.2.20.6.1.37.2', null, 'PvcDestName2', 'PVC2对端名称', null, null, null, null, null, null, null, null, '2011-11-28 15:49:23', '2011-11-28 15:51:48', null, '14', '1', null, null), ('225', '20', 'PVC2的DLCI号', '1.3.6.1.4.1.727.7.2.20.6.1.21.2', null, 'PvcDlci2', 'PVC2的DLCI号', null, null, null, null, null, null, null, null, '2011-11-28 15:50:54', '2011-11-28 15:51:48', null, '13', '1', null, null), ('229', '2', '复用器名称', '1.3.6.1.4.1.727.7.2.1.3.0', null, 'SysName', '复用器名称', null, null, null, null, null, null, null, null, '2011-12-16 09:43:26', '2011-10-26 09:13:12', null, '1', '1', null, null), ('230', '2', '主站收坏帧增量', '1.3.6.1.4.1.727.7.2.20.2.1.12.4', null, 'RxBadFrame2', '广域口2坏帧数', null, '10.00', null, '30', '3600', '-1.00', null, null, '2011-12-16 09:43:34', '2011-12-22 10:05:17', '4', '5', '1', null, null), ('231', '2', '广域口2状态', '1.3.6.1.4.1.727.7.2.20.2.1.7.2', null, 'WanStatus2', '广域口2状态', null, null, null, null, null, null, null, null, '2011-12-16 09:43:42', '2011-12-16 10:44:24', null, '4', '1', '', null), ('232', '2', 'PVC2状态', '1.3.6.1.4.1.727.7.2.20.6.1.6.2', null, 'PvcStatus2', 'PVC2状态', null, null, null, null, null, null, null, null, '2011-12-16 09:43:57', '2011-12-16 10:44:24', null, '8', '1', null, null), ('233', '2', 'PVC2的DLCI号', '1.3.6.1.4.1.727.7.2.20.6.1.21.2', null, 'PvcDlci2', 'PVC2的DLCI号', null, null, null, null, null, null, null, null, '2011-12-16 09:44:07', '2011-12-16 10:44:15', null, '9', '1', null, null), ('234', '2', 'PVC2对端名称', '1.3.6.1.4.1.727.7.2.20.6.1.37.2', null, 'PvcDestName2', 'PVC2对端名称', null, null, null, null, null, null, null, null, '2011-12-16 09:44:15', '2011-12-16 10:44:15', null, '10', '1', null, null), ('236', '7', '主站收 Eb/N0', '1.3.6.1.4.1.6247.27.1.3.4.1.1.7.3', null, 'EbN03', '端口3 Eb/N0', '', '12.00', '7.00', '5', '60', '-1.00', null, null, '2011-12-16 11:00:20', '2011-12-15 13:30:22', '4', '13', '1', 'dB', '10'), ('237', '7', '端口3 接收电平', '1.3.6.1.4.1.6247.27.1.3.4.1.1.6.3', null, 'MoRSL3', '端口3 接收电平', null, null, null, '5', null, '-1.00', null, null, '2011-12-16 11:00:48', '2011-11-28 14:30:08', null, '14', '1', 'dBm', null), ('238', '7', '端口3 接收频偏', '1.3.6.1.4.1.6247.27.1.3.4.1.1.5.3', null, 'MoFreqOffset3', '端口3 接收频偏', null, null, null, '5', null, '-1.00', null, null, '2011-12-16 11:01:13', '2011-11-28 14:30:08', null, '15', '1', 'KHz', '1000'), ('239', '7', '端口3 修正误码率', '1.3.6.1.4.1.6247.27.1.3.4.1.1.3.3', null, 'MoCBER2', '端口3 修正误码率', null, null, null, '5', null, '-1.00', null, null, '2011-12-16 11:01:36', '2011-12-15 13:28:18', null, '16', '1', '10E-9', null);
COMMIT;

-- ----------------------------
--  Table structure for `u_grant`
-- ----------------------------
DROP TABLE IF EXISTS `u_grant`;
CREATE TABLE `u_grant` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gid` int(11) DEFAULT NULL COMMENT 'group id',
  `uid` int(11) DEFAULT NULL,
  `dt_create` datetime DEFAULT NULL,
  `dt_modify` datetime DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `pm_menu` varchar(255) DEFAULT NULL,
  `pm_entity` varchar(255) DEFAULT NULL,
  `pm_oper` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `u_grant`
-- ----------------------------
BEGIN;
INSERT INTO `u_grant` VALUES ('1', '2', null, null, null, null, null, '1', '全部', '3'), ('2', '1', null, null, null, null, null, '1', '全部', '3'), ('3', '1', null, null, null, null, null, '5', '无', null), ('4', '1', null, null, null, null, null, '7', '无', null), ('5', '3', null, null, null, null, null, '4', '全部', '3'), ('6', '4', null, null, null, null, null, '4', '全部', '3');
COMMIT;

-- ----------------------------
--  Table structure for `u_group`
-- ----------------------------
DROP TABLE IF EXISTS `u_group`;
CREATE TABLE `u_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `dt_create` datetime DEFAULT NULL,
  `dt_modify` datetime DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `u_group`
-- ----------------------------
BEGIN;
INSERT INTO `u_group` VALUES ('1', null, null, '2010-12-06 10:17:13', '业务管理员,负责用户管理及权限分配,可定制生成各种统计报表,查看实时监测图', null, 'admin'), ('2', null, null, '2011-03-21 13:59:30', '系统管理员,负责确保系统的正常运行\n包括:监测对象维护,系统版本更新等11', null, 'sys'), ('3', null, '2010-12-06 10:09:56', '2010-12-06 10:16:12', '外台值班人员,可提交工作日志并查看回复', null, 'user');
COMMIT;

-- ----------------------------
--  Table structure for `u_user`
-- ----------------------------
DROP TABLE IF EXISTS `u_user`;
CREATE TABLE `u_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gid` int(11) NOT NULL COMMENT 'group id',
  `uid` int(11) DEFAULT NULL,
  `dt_create` datetime DEFAULT NULL,
  `dt_modify` datetime DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT '1',
  `user_id` varchar(255) NOT NULL DEFAULT '',
  `pwd` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `tel` varchar(255) DEFAULT NULL,
  `dt_login` datetime DEFAULT NULL,
  `dt_logout` datetime DEFAULT NULL,
  `online` int(11) DEFAULT NULL,
  `handle` varchar(255) DEFAULT NULL COMMENT '登录之后的句柄',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uid` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `u_user`
-- ----------------------------
BEGIN;
INSERT INTO `u_user` VALUES ('1', '1', null, null, '2012-02-25 16:33:37', null, null, 'usr1', 'f786b8a669be38367d1e0915a18ee2d2', '姓名1', null, '2012-03-22 06:19:21', '2012-05-10 08:28:28', '0', '43262f8f-ecdf-4b20-b662-d0b072e9c9cb'), ('2', '2', null, '2010-10-08 15:14:15', '2010-12-06 13:39:26', null, null, 'usr2', 'cc733b47bef329b546dab60f1a204100', '姓名2', null, '2012-01-13 16:40:39', '2012-04-27 18:00:12', '0', '0f9e35da-4fe0-446b-a26f-1cd829834587'), ('5', '3', null, null, '2011-01-11 09:46:50', null, null, 'usr5', 'dcbfffc60105b72dc298b6dc15ab3141', '姓名5', null, '2011-03-21 13:54:19', '2011-03-21 13:56:36', '0', '6d613522-7911-4a21-9092-51348f95248f'), ('12', '3', null, '2011-01-07 09:56:59', '2011-01-13 16:04:21', null, null, 'usr12', '3e2393c7142397e2644144ff9793de15', '姓名12', null, '2012-01-18 16:21:30', '2012-01-18 16:21:33', '0', '71bd576e-7cd2-4f9d-b327-796e90f72b23'), ('16', '2', null, '2011-01-07 10:03:24', '2011-01-28 11:28:30', null, null, 'usr16', 'c04eacc1f47cbd1812e8884bacdf9093', '姓名16', null, null, null, '0', null), ('17', '1', null, '2011-01-28 11:28:12', '2011-03-21 10:09:07', null, null, 'usr17', '61eb90fbf2e589705f4d92887a7bef7e', '姓名17', null, '2011-03-21 13:51:01', '2011-03-21 13:52:48', '0', 'bd5d6946-308e-4806-9a9b-d822a07e62c9'), ('18', '1', null, '2011-03-21 13:26:56', '2011-03-21 13:27:04', null, null, 'usr18', '3ee401dc434f489f49f1a2bd8fac0d6c', '姓名18', null, null, null, '0', null), ('19', '3', null, '2011-03-22 09:24:45', '2011-03-22 09:25:18', null, null, 'usr19', '08327153d748a499a621485a837ec4fc', '姓名19', null, '2011-03-22 09:25:28', '2011-03-22 09:36:34', '0', 'bfb4a566-dcdf-4e26-960b-70bc2f36140c');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
